package com.hos.db.create.user;

/**
 * 用户信息
 * Created by guom on 2018/10/15.
 */
public class UserPatTable {
    public static String tableName = "user_pats";
    public static String tableId = "id";
    public static String tablePatId = "pat_id";//患者id
    public static String tablePatName = "pat_name";//患者姓名
    public static String tablePatPhone = "pat_phone";//患者手机号
    public static String tablePatAccount = "pat_account";//患者账号
    public static String tablePatPwd = "pat_pwd";//患者密码
    public static String tablePatNickname = "pat_nickname";//患者昵称
    public static String tablePatPortrait = "pat_portrait";//患者头像
    public static String tablePatRegisterTime = "pat_register_time";//患者注册时间
    public static String tablePatBirthday = "pat_birthday";//患者生日
    public static String tablePatSex = "pat_sex";//患者性别
    public static String tablePatIdentityNumber = "pat_identity_number";//患者身份证
    public static String tablePatAddress = "pat_address";//患者地址
    public static String tablePatPushId = "pat_pushid";//推送id
    public static String tablePatDevice = "pat_device";//设备
    public static String tablePatWXId = "pat_wx_id";//患者微信id
    public static String tablePatLoninTime = "pat_login_time";//患者登录时间
    public static String tablePatToken = "pat_token";
    //状态 1：审核状态 2：审核通过状态
    public static String tablePatState = "pat_state";
    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableId + "  int, "
            + tablePatId + " varchar(100), "
            + tablePatName + " varchar(100), "
            + tablePatPhone + " varchar(100), "
            + tablePatAccount + " varchar(100) primary key, "//主键
            + tablePatPwd + " varchar(100), "
            + tablePatNickname + " varchar(100), "
            + tablePatPortrait + " varchar(100), "
            + tablePatRegisterTime + " datetime,"
            + tablePatBirthday + " varchar(100), "
            + tablePatSex + " varchar(100), "
            + tablePatIdentityNumber + " varchar(100), "
            + tablePatAddress + " varchar(100), "
            + tablePatState + " int, "
            + tablePatPushId + " varchar(100), "
            + tablePatDevice + " varchar(100), "
            + tablePatToken + " varchar(100), "
            + tablePatWXId + " varchar(100), "
            + tablePatLoninTime + " varchar(100)"
            + "); ";

}
